Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
LoyaltyProgramAccountPointsRedemptionID (FK) | Token identifier for a LoyaltyProgramAccountPointsRedemption entity type instance. | ID_LYLT_PRGM_ACNT_PNT_RDM | Identity | integer | Z_CustomerMembershipRedemptionJournal(CO_LYLT_PRGM_ACNT_PNT_RDM) |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ZCustomerRewardRedemptionLineItem(TR_LTM_LYLT_AW) |
RetailTransactionLineItemSequenceNumber (FK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | ZCustomerRewardRedemptionLineItem(TR_LTM_LYLT_AW) |
BusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | PhysicalCountLineItem(TR_LTM_PHY_CNT) |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TestDelivery(TR_DV_TST) |
ItemInventoryJournalEntryID (PK) | A unique system assigned identifier for the record of a change in an ItemInventory holding that is applied to an ItemInventory account. | ID_JR | Identity | integer | |
LocationID (FK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | ItemInventory(LE_INV_ITM) |
BusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | InventoryAdjustmentLineItem(TR_LTM_INV_ADJ) |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
InventoryControl (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | INV_CTL | IdentityUUID | char(32) | FulfillmentAcknowledgementLineItem(TR_LTM_FLF_ACK) |
RetailTransactionLineItemSequenceNumber (FK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
InventoryControlDocumentID (FK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |
InventoryControlDocumentLineItemID (FK) | A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. | IC_LTM_ICD | LineNumber | smallint | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | ItemInventory(LE_INV_ITM) |
InventoryAdjustmentDocumentID (FK) | A unique identifier for an INVENTORY ADJUSTMENT DOCUMENT which lists adjustments between actual and notified amounts. | ID_DCM_INV_ADJT | Identity | integer | InventoryAdjustmentLineItem(TR_LTM_INV_ADJ) |
InventoryAdjustmentLineNumber (FK) | The line number for a specific line item adjustment. | IC_INV_ADJT | LineNumber | smallint | InventoryAdjustmentLineItem(TR_LTM_INV_ADJ) |
PhysicalItemCountLineNumber (FK) | The physical count line item. | IC_CNT_PHY_ITM | LineNumber | smallint | PhysicalCountLineItem(TR_LTM_PHY_CNT) |
PhysicalCountDocumentID (FK) | The identifier for the physical count document on which the actual item counts are recorded. | ID_DCM_PHY_CNT | Identity | integer | PhysicalCountLineItem(TR_LTM_PHY_CNT) |
FuelingTransactionID (FK) | A unique identifier for the fuelling transaction that is being posted to the ItemInventory via this journal entry. | ID_TRN_FUEL | Identity | integer | FuelingTransaction(EV_TR_FUEL) |
DateTimestamp | The time and date when the ItemInventoryJournalEntry is recorded. | TS_ENR_JR | AuditDateTime | datetime | |
RetailUnitCount | The change in the number of units of a specific Item that is being posted to the ItemInventory via this journal entry. | QU_UN_RT | Quantity | DECIMAL(9,3) | |
ItemInventoryStateID (FK) | A unique retailer assigned identifier for ItemInventoryStates. | ID_ST_INV | Identity | integer | ItemInventory(LE_INV_ITM) |
FulfillmentAcknowledgementLineItemSequenceNumber (FK) | The sequence number of line item within the context of this FulfillmentAcknowledgmentTransaction. | IC_LTM_FLF_ACK | LineNumber | smallint | FulfillmentAcknowledgementLineItem(TR_LTM_FLF_ACK) |
RevenueCostCenterID (FK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | ItemInventory(LE_INV_ITM) |